--
--
-- Listing A - Test Query
--


SELECT items.id
FROM items 
LEFT JOIN (

	-- Query i.
	SELECT 	items.id
	FROM items
	LEFT JOIN (

		-- Query ii.
		SELECT id FROM items WHERE number = 1

	) AS moded_items USING (id)
	WHERE moded_items.id IS NULL

) AS sub_items USING (id)
WHERE sub_items.id IS NULL;









--
--
-- Listing B - The Working Setup
--

BEGIN;

CREATE TABLE items AS
SELECT
	id::INTEGER,
	NULL::INTEGER as number
FROM generate_series(1, 10000) AS id;

UPDATE items SET number = 1 WHERE id = 500;
UPDATE items SET number = 1 WHERE id = 600;

COMMIT;







--
--
-- Listing C - The Setup That Breaks My Test Query
--

-- Does not work

BEGIN;

CREATE TABLE items AS
SELECT
	id::INTEGER,
	'field that has lots of text to make this table more expensive to scan more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more
more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text 
more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text 
more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text 
more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text more text v
more text more text more text  text more text more text more text more text more text '::VARCHAR AS field1,
	NULL::INTEGER as number
FROM generate_series(1, 10000) AS id;

ALTER TABLE items ADD CONSTRAINT items_pkey PRIMARY KEY(id);

UPDATE items SET number = 1 WHERE id = 500;
UPDATE items SET number = 1 WHERE id = 600;

COMMIT;